MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 742

View and edit SQL

Suggested facets: Object Name, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
206448 17.3.2985 0 0 333792 Drawings and Prints 11 Album 1119 Illustrations of the Pilgrims of the Rhine [Proofs]           Illustrator|Designer|Publisher|Author 975   Thomas Hood|David Roberts|Saunders and Otley|Edward Bulwer-Lytton, 1st Baron Lytton British, London 1799–1845 London|British, Stockbridge, Scotland 1796–1864 London|London|British, London 1803–1873 Torquay   Hood, Thomas|Roberts, David|Saunders and Otley|Bulwer-Lytton, Edward 17305 British|British, Scottish|British|British 742 1799 |1796 |1800 |1803 1845 |1864 |1899 |1873 1834 1834 1834 Illustrations: etching 28943 18 11/16 x 12 1/8 x 5/8 in. (47.4 x 30.8 x 1.6cm) Harris Brisbane Dick Fund, 1917                       Albums|Prints 462   Metropolitan Museum of Art, New York, NY 1
206546 27.7(1-26) 0 0 333890 Drawings and Prints 11 Album 1119 An Alphabet           Artist|Sitter|Sitter|Sitter 997 portrait of|Portrait of|portrait of William Nicholson|James Pryde|William Nicholson|Sir Herbert Beerbohm Tree British, Newark-on-Trent 1872–1949 Berkshire|British, Edinburgh, Scotland 1866–1941 London|British, Newark-on-Trent 1872–1949 Berkshire|British, London 1852–1917 London , "A is for Artist" is a caricature Nicholson, William|Pryde, James|Nicholson, William|Tree, Herbert Beerbohm Sir 17349 British|British, Scottish|British|British 742 1872 |1866 |1872 |1852 1949 |1941 |1949 |1917 1898 [1897] 1897 1898 Wood engraving 29001 Book: 18 1/16 x 14 5/8 x 1 15/16 in. (45.8 x 37.2 x 5cm) Harris Brisbane Dick Fund, 1927                       Albums|Prints 462   Metropolitan Museum of Art, New York, NY 1
214356 52.517 0 0 341776 Drawings and Prints 11 Book 97 An Historical Memento, Representing the Different Scenes of Public Rejoicing, which took place the first of August, in St. Jame's and Hyde Parks, London, in Celebration of The Glorious Peace of 1814, and of the Centenary of the Accession...           Artist|Artist|Author|Publisher 1334 After|Introduction by|Edited and published by Matthew Dubourg|John Heaviside Clark|Francis William Blagdon|Edward Orme British, active 1786–1838|British (born Scotland), 1771–1863 Edinburgh|British, baptised London 1777–1819|British, Manchester 1775–1848 London , London Dubourg, Matthew|Clark, John Heaviside|Blagdon, Francis William|Orme, Edward 20058 British|British, Scottish|British|British 742 1786 |1771 |1775 |1775 1838 |1863 |1819 |1848 1814 1814 1814 Illustrations: hand-colored aquatint 33138 14 15/16 x 11 x 1/2 in. (38 x 28 x 1.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1952                       Books 442   Metropolitan Museum of Art, New York, NY 1
225068 43.90.2 0 0 352662 Drawings and Prints 11 Book 97 A Description of the Colosseum...and Panorama of London           Publisher|Binder|Printer|Printer 2867 Plates embossed by Kronheim & Skirving|Ramace|Dobbs, Bailey & Co.|J. Wertheimer & Co. London|Edinburgh|British, active 19th century|London   Kronheim & Skirving|Ramace|Dobbs, Bailey & Co.|Wertheimer, J. & Co. 26705 British|British, Scottish|British|British 742 1800 |1800 |1800 |1800 1900 |1900 |1900 |1900 1845 1845 1845 Illustrations: stereotype and embossing 35485 7 1/2 x 9 1/8 x 3/8 in. (19 x 23.2 x 1 cm) Harris Brisbane Dick Fund, 1943                       Books 442   Metropolitan Museum of Art, New York, NY 1
226132 66.540.15 0 0 353738 Drawings and Prints 11 Book 97 Reynard the Fox or the Ghost Heath Run           Author|Illustrator|Publisher|Printer 1121   John Edward Masefield|George Denholm Armour|William Heinemann Ltd.|Richard Clay & Sons, Limited British, Ledbury, Herefordshire 1878–1967 Abingdon|British, North Lanarkshire, Scotland 1864–1949|London|London and Bungay, Suffolk Masefield, John Edward|Armour, George Denholm|Heinemann,William Ltd.|Clay, Richard & Sons, Limited 27452 British|British, Scottish|British|British 742 1878 |1864 |1850 |1850 1967 |1949 |1950 |1980 1921 1921 1921 Illustrations: photomechanical reproduction and wood engraving 35615 12 x 9 1/4 x 13/16 in. (30.5 x 23.5 x 2.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966                       Books 442   Metropolitan Museum of Art, New York, NY 1
227765 1991.1073.51 0 0 355386 Drawings and Prints 11 Book 97 A Picture of St. Petersburg, Represented in A Collection of Twenty interesting Views of the City, the Sledges and the People           Artist|Artist|Artist|Publisher 853 After Mornay|John Heaviside Clark|C. M. Dubourgh|Edward Orme British, active 19th century|British (born Scotland), 1771–1863 Edinburgh|British, active 19th century|British, Manchester 1775–1848 London   Mornay|Clark, John Heaviside|Dubourgh, C. M.|Orme, Edward 28613 British|British, Scottish|British|British 742 1800 |1771 |1800 |1775 1900 |1863 |1900 |1848 1815 1815 1815 Illustrations: hand colored aquatint 35054 18 1/2 x 13 3/4 x 13/16 in. (47 x 35 x 2 cm) Jane E. Andrews Fund, in memory of William Loring Andrews, 1946, transferred from the Library (1991.1073.51)   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 146.866ms · Data license: CC0 · Data source: metmuseum/openaccess